Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Trigger
1) A CREATE TRIGGER statement that corrects mixed-case state names
2) A script that creates AFTER triggers to maintain referential integrity
3) A statement that deletes the trigger
4) After its data has been deleted, the trigger deletes corresponding rows from the sales and discounts tables
5) ALTER a TRIGGER
6) An after-update trigger
7) Auditing Triggers
8) Cascade Update Triggers
9) Check @@ROWCOUNT in a trigger
10) Check business logic in a trigger
11) Check record matching in a trigger
12) COLUMNS_UPDATED() function
13) Controlling Trigger Recursion
14) Count for DELETED
15) Count Inserted table
16) COUNT() FROM Inserted
17) CREATE INSTEAD OF DELETE TRIGGER ON a view
18) CREATE TRIGGER FOR DELETE
19) CREATE TRIGGER FOR INSERT, UPDATE
20) CREATE TRIGGER FOR INSERT, UPDATE, DELETE
21) Create TRIGGER for update
22) CREATE TRIGGER prevent_drop_triggers ON DATABASE FOR DROP_TRIGGER
23) Creating a DDL Trigger that Audits Database-Level Events
24) Creating a DDL Trigger that Audits Server-Level Events
25) Creating the UpdateLog table and an update trigger on the authors table
26) Define variables in a trigger
27) Disable a trigger
28) Enable a trigger
29) Exits if the price column has not been updated
30) Get day from a datetime value
31) Inserted table Demo
32) Inserted, deleted pseudo table
33) INSTEAD OF INSERT on a view
34) INSTEAD OF INSERT trigger for a table
35) INSTEAD OF UPDATE trigger on a view
36) Is UPDATing a certain column
37) Join Inserted table with real table
38) Modifying a Trigger
39) One table with two after-delete triggers
40) RAISERROR in trigger
41) Rollback transaction in a trigger
42) Rolling Back in an AFTER Trigger
43) Setting Trigger Firing Order
44) Specifying Trigger Firing Order
45) Table for INSTEAD OF Trigger for Logical Deletes
46) The syntax of the ALTER TRIGGER statement
47) The syntax of the CREATE TRIGGER statement
48) The syntax of the DROP TRIGGER statement
49) The trigger rolls back any T-SQL that changes the advance column
50) The UPDATE() Function
51) Trigger for delete and deleted table
52) Trigger for delete using deleted table
53) Trigger FOR INSERT, UPDATE
54) Trigger Scripts for Cascading DELETEs
55) Update table in a trigger
56) Using an AFTER Trigger to Remove Time from a datetime Column